Importing Selection Field Values

Single Selection and Multi-Selection fields present values defined in SBM Composer to end users as they work with items. To ease the process of managing multiple selection values, use the import and export features to quickly add new selections and update existing selections at one time.

The import and export options are located on the More list in the Values area for Single Selection and Multi-Selection fields. For import steps, refer to Import Steps.

Import/Export Format

Selection values are imported from and exported as comma-separate values (.csv). You can create a .csv file that uses the format described in this section, or you can export values from an existing selection field that has at least one selection value, and then modify the content to meet your needs.

Once you have a .csv file, you can open it in Microsoft Excel for simpler editing of values.

The following example shows comma-separate columns for values exported from a Single Selection field.

Each line represents a selection value. Each column in a line is described in the table that follows.

CSV Column	Required?	Export Information	Import Information
UUID (Unique Identifier)	No, but review description.	Provided on export so that you can update values in the file and then reimport them into the same field.	If a selection value with the specified UUID exists, the value is updated with the name, status and weight in the .csv file. If a UUID is not provided or a match is not found, a new selection is added. If included during an import, UUID information must be listed first in each line.
Value Name	Yes	Exported values are surrounded by double quotation marks.	If duplicate name values are found, a number is added to the end of the name and incremented for each duplicate value found. For example, multiple "Priority - High" values would be imported as "Priority - High 1," Priority High - 2," etc. Values do not need quotation marks to be imported unless the value contains embedded quotation marks, which must be surrounded by double quotations marks. For example, Priority - "High" needs to be imported as "Priority - ""High""". Commas included inside of quotation marks are not treated as separators but are included as part of the value.
Enabled Status	No	"True" indicates enabled status; "False" indicates disable status.	If a line does not contain a Status boolean value, it is set to True and the selection is enabled.
Weight (Single Selection fields only)	No		If a weight is not specified, the default weight of 100 is used.

For details on options for selection fields, refer to:

Import Steps

You can use the import and export features to easily manage values for Single Selection and Multi-Selection fields.

Use these steps to quickly add new selection values or to edit multiple existing values at the same time.

To import selection field values:

In the App Explorer, select Data Design, and then select the table that contains a Single Selection and Multi-Selection field.
Select the field, select the Options tab, and then do one of the following:
- If the field already has at least one value, select Export from the More list, and then export the existing values to a file. Edit the file as needed, using the information in Importing Selection Field Values for guidance.
- If the field does not have any values, create a spreadsheet following the criteria in Import/Export Format.
Select Import from the More list, and then navigate to your data file.
Tip: If you are not satisfied with the results, use the Undo feature to return the value list to its original state.